Comments by Member 12385326 (Top 95 by date)

yes it is also working fine if i use ado.net entity model. but is is not working if i use code first from database option of data model though it is generating model view controller directly from database.
i tried alot.still not getting

i tried.there is no problem in controller. i am getting proper id from controller into javascript in alert box.problem starts from success function.

@karthik hey i got proper op..thnx a lot for ur valuable time.
i did this:
$("#CustomerName").val(response.Customer_Name)+""+$("#Address").val(response.Billing_Address);

name is correct. but i when i hide one textbox like this
//$("#CustomerName").val(response.Customer_Name);
$("#Address").val(response.Billing_Address);

it is respective value in another textbox.
means at a time it is showing only one textbox value

@KARTHIK..hey fixed it..and it is showing related data in 1 textbox.but not in other textbox

yes it is present.

@karthik hey i got int inputid=2 i.e orrect value.
but for
var item = acc.tbl_CustomerCreation.FirstOrDefault(k => k.Account_No== inputid);

i am getting null value

i am not getting dropdownValue in Method of controller.
there are two items in db.yes id passed from ajax mached with item in db table.

no i have values in database. and that value (Account_No) i am populating in dropdownlist. i am not getting respective values in textboxes.

yes i am getting inputid null

@karthik i got error for this new script

parsererror syntaxerror: unexpected end of JSON input [object object]

i am getting item as null while debugging

i tried that only

method:

public ActionResult GetValuesFromDatabase(string inputId)
{
int inputid = Convert.ToInt32(inputId);
using (AccountDBEntities3 acc = new AccountDBEntities3())
{

var item = acc.tbl_CustomerCreation.FirstOrDefault(k => k.Account_No == inputid);
if (item != null)
return Json(item);
else
return null;
}
}


script:
<script>
function copyValue1() {
debugger;
var inputID = $("#SalesOrderAccNoDropDown1").val();
$.ajax({
type:'GET',
url: '/Quotation/GetValuesFromDatabase',//Change the function name with your actual function name
datatype: 'application/json',
contentType: 'application/json',
//data: { inputid: $("#SalesOrderAccNoDropDown1").val() },
data: JSON.stringify({ inputID: +inputID }),

success: function(response) {
//assign values to your textboxes.
$("#CustomerName").val(response.Customer_Name);
$("#Address").val(response.Biliing_Address);
alert(inputID)
alert(response.Biliing_Address)
},
error: function(){alert("Whooaaa! Something went wrong..")},
});
}
</script>

@karthik i debuged that method..it is not allowing to enter below this line

using (AccountDBEntities3 acc = new AccountDBEntities3())


and also i put alert in my script to chek whether it is taking value or not..
i am getting value of inputID by this alert
alert(inputID)
but i am getting "undefined" by this alert
alert(response.Biliing_Address)

see KARTHIK this is my method in controller:
public JsonResult GetValuesFromDatabase(string inputId)
{
// int inputid = Convert.ToInt32(inputId);
using (AccountDBEntities2 acc = new AccountDBEntities2())
{
var firstValue = from c in acc.tbl_CustomerCreation where c.Account_No==inputId
select c.Customer_Name ; //Get this from database;
var secondValue = from c in acc.tbl_CustomerCreation
where c.Account_No == inputId
select c.Billing_Address; ; //Get this from database;
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
string result = javaScriptSerializer.Serialize(firstValue);
string result1 = javaScriptSerializer.Serialize(secondValue);
return Json(result,result1, JsonRequestBehavior.AllowGet);
}
}


this is my script in view:
<script>
function copyValue1(){
$.ajax({
type: "GET",
url: "/Quotation/GetValuesFromDatabase",//Change the function name with your actual function name
dataType: "Json",
data: { inputId: $("#SalesOrderAccNoDropDown1").val() },
success: function(response) {
//assign values to your textboxes.
$("#CustomerName").val(response.result);
$("#Address").val(response.result1);
}
});
}
</script>


this is my dropdown and textboxes in view:
@Html.DropDownList("Acc_No", (IEnumerable<SelectListItem>)ViewBag.Acc_No, "select UnderGroup", new { @class = "form-control", @id = "SalesOrderAccNoDropDown1", @onchange = "copyValue1()" })



textboxes:
<tr>
<td>
@Html.LabelFor(model => model.CustomerName, htmlAttributes: new { @class = "control-label col-md-2" })
</td>
<td>

@Html.EditorFor(model => model.CustomerName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.CustomerName, "", new { @class = "text-danger" })

</td>
<td>
@Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
</td>
<td>
@Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
</td>
</tr>

it is not throwing error but not giving expected op also.

in that query only i m confused.also it is throwing error for value1 and value 2.what can be its datatype?

i tried this as suggested before onthis site but am confused over method in controller.we are passing inuptID in method parameter but i am not able to write query for Firstvalue and SecondValue in controller.plz guid me on this.

this is method in controller:
public JsonResult GetValuesFromDatabase(int inputId){
//Perform database query here and assign that value to the variables to be returned.
var firstValue = "Value for TextBox1"; //Get this from database;
var secondValue = "Value for TextBox2"; //Get this from database;
var jsonData = new
{
value1: firstValue,
value2: secondValue
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}

and this is scrip in View:
function copyValue1(){
$.ajax({
type: "GET",
url: "/YourControllerName/GetValuesFromDatabase",//Change the function name with your actual function name
dataType: "Json",
data: { inputId: $("#YourDropdownList").val()},
success: function (response) {
//assign values to your textboxes.
$("#Textbox1").val(response.value1);
$("#Textbox2").val(response.value1);
}
});
}

i have this code in my controller. m i doing right?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MathuraApp.Repository;
using MathuraApp.Models;

namespace MathuraApp.Controllers
{
public class CurrencyCreationController : Controller
{
// GET: CurrencyCreation

public ActionResult Converter()
{
return PartialView();
}
public ActionResult currency()
{
return PartialView();
}


[HttpPost]
public ActionResult currency(CurrencyCreationModel ccm)
{
try
{
if (ModelState.IsValid)
{
CurrCreRep ccr = new CurrCreRep();

if (ccr.Currency(ccm))
{
ViewBag.Message = "Currency details added successfully";
}
}

return PartialView(ccm);
}
catch
{
return PartialView(ccm);
}
}


public ActionResult Converter(CurrencyCreationModel ccm)
{
try
{
if (ModelState.IsValid)
{
CurrCreRep ccro = new CurrCreRep();

if (ccro.Converter(ccm))
{
ViewBag.Message = "Currency details added successfully";
}
}

return PartialView(ccm);
}
catch
{
return PartialView(ccm);
}
}


}
}

and i have doubt onn this line in my view :
<div class="tab-pane active " id="tab_1_2">
@using (Html.BeginForm("Converter", "CurrencyCreationController", FormMethod.Get,new { }))
{


and

<div class="tab-pane " id="tab_1_1">

@using (Html.BeginForm("currency", "CurrencyCreationController", FormMethod.Get,new{ }))


the code is working partially..i mean i can insert only one tab's data in database.i want both the tab should be working

i want to create 3 tabs in my asp.net web page. i am using mvc. how to create it i mean how many controller,models and view i need to create. i tried with one model,controller and view. in my view there is design for tabs. but when i run it ,it is not inserting data of second tab;it is inserting data of first tab only. though i have procedure in backend.that i am calling from frontend.

i want some data from another table into main table.
like i said i have 3 tables. and i m trying to insert data from "table 2 and table 3" he into "table 1". in table 1 i have dropdownlist for the data from another table.
i.e group_name & undergroup(from table 2) for this i have dropdown list in table 1(itemcreation)
same for unit table.


INSERT INTO tbl_ItemCreation
SELECT @Item_Name,@Item_Code,t1.ItemGroup_Id,t1.UnderGroup,t1.Group_Name ,t2.Unit_Id
FROM tbl_ItemGroup t1,tbl_UnitCreation t2 where UnderGroup=@UnderGroup

and i have condition
for eg: group name='nokia'
undergroup='mobile'
i want group_name on the selection of undergroup in table 1

this is my itemgroup prcedure for insert:
USE [AccountDB]
GO
/****** Object: StoredProcedure [dbo].[spr_ItemGroup] Script Date: 4/6/2016 3:51:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spr_ItemGroup]
@Group_Name varchar(50)=null,
@Chbox_Val varchar(50)=null,
@UnderGroup varchar(50)=null,
@Comments varchar(50)=null,
--@flag varchar(50)=null,
@abc varchar(50)=null



AS
BEGIN



set nocount on;

DECLARE @ItemGroup_id int

IF ((SELECT COUNT(Group_Name ) FROM tbl_ItemGroup WHERE Group_Name = @Group_Name
GROUP BY Group_Name) > 0)
begin
SET @ItemGroup_id = NULL
print 'Item Exists'
end
else
begin
IF @abc='insert' and @Chbox_Val='yes'

begin
insert into tbl_ItemGroup(Group_Name,Chbox_Val ,UnderGroup,Comments )
values(@Group_name,@Chbox_Val,'',@Comments)
set @ItemGroup_id= SCOPE_IDENTITY();
print 'block1'
end


else if @abc='insert' and @Chbox_Val='no'

begin
print 'block3'


insert into tbl_ItemGroup select @Group_name,'no',[Group_Name],@Comments from tbl_ItemGroup where Group_Name=@UnderGroup and Chbox_Val='yes'

set @ItemGroup_id= SCOPE_IDENTITY();
end


end
end




this is my unit procedure for insert":
USE [AccountDB]
GO
/****** Object: StoredProcedure [dbo].[spr_UnitCreation] Script Date: 4/6/2016 3:52:35 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[spr_UnitCreation]

@Unit_Name varchar(50)=null,
@Unit_Abbreviation varchar(50)=null,
@Unit_type varchar(50)=null,
@Decimal_Places varchar(50)=null,
@Description varchar(50)=null,
@Super_Unit varchar(50)=null,
@Per_Unit varchar(50)=null,

--@Unit_Id int output,
@abc varchar(50)=null


As
begin
if @@ROWCOUNT=0
begin
if @abc='insert' and @Unit_Type='Single'
begin
set nocount on;
DECLARE @Unit_Id int
insert into tbl_unitCreation (Unit_Name,Unit_Abbreviation,Unit_type,
Decimal_Places,Description,Super_Unit,Per_Unit )values (@Unit_Name,@Unit_Abbreviation,@Unit_type,@Decimal_Places,@Description,@Super_Unit,@Per_Unit )
set @Unit_Id=scope_identity();

end

if @abc='insert' and @Unit_Type='Compound'
insert into tbl_unitCreation select @Unit_Name,@Unit_Abbreviation,@Unit_type,@Decimal_Places,@Description,[Unit_Name],@Per_Unit
from tbl_UnitCreation where Unit_Name=@Super_Unit and Unit_Type='Single'
set @Unit_Id=scope_identity();





end



end

select * from tbl_UnitCreation


both are working fine.

now i want third procedure for my itemcreation table.which will fetch values of group name and undergroup from itemgroup table and unit name from unit table.

and this is my query for insert in itemcreation

INSERT INTO tbl_ItemCreation
SELECT @Item_Name,@Item_Code,t1.ItemGroup_Id,t1.UnderGroup,t1.Group_Name ,t2.Unit_Id
FROM tbl_ItemGroup t1,tbl_UnitCreation t2 where UnderGroup=@UnderGroup and Group_Name=(select Group_Name from tbl_ItemGroup where Chbox_Val='no' and @UnderGroup in (select under from @data ))

INSERT INTO tbl_ItemCreation
SELECT @Item_Name,@Item_Code,t1.Group_Name,t1.underGroup ,t2.Unit_Id,t1.ItemGroup_Id
FROM tbl_ItemGroup t1,tbl_UnitCreation t2 where Group_Name=@Group_Name and UnderGroup=(select Group_Name from tbl_ItemGroup where Chbox_Val='no' and @Group_Name=Group_Name)

i tried this.because join is not the thing i was wanted.i dont simply want to join tables. i want to fetch record from another two table into first table on the selection of respective value

yeah the code u posted above is error free..but not giving expected result.
i should use foreign key or not?i mean i am confused over which column should be there in table 1 i.e itemcreation.to get data from another table.column name or its primary key?

DECLARE @data TABLE (under VARCHAR(100));
INSERT INTO @data
select Group_Name
from tbl_AccountGroup
where @UnderGroup='Sales A/C'


begin
IF @abc='insert' and (@Group_Name='Sales A/c' or @Group_Name IN (SELECT under FROM @data ))
i tried this.
but still is not working

i am not getting it..can you show it with my example?

i want to update my user defined record only not system record. but if i use above query then it is updatating every record which are not in where condition.