public void UpdateOrganizationDetails(OrganizationModels organization)
{
SqlConnection conMyData;
string strInsert;
SqlCommand cmdInsert;
conMyData = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
conMyData.Open();
strInsert = "update Organisation set CompanyID=@CompanyID,DealerName=@DealerName,DealerShip=@DealerShip,Address=@Address,City=@City,State=@State,Country=@Country ,PhoneNo=@PhoneNo ,FaxNo=@FaxNo ,Email=@Email,Website=@Website,TinNo=@TinNo,Entrytax=@Entrytax ,FoodLicNO=@FoodLicNO,WM=@WM ,Logo=@Logo,Div_Office=@Div_Office,Message=@Message,VAT_Rate = @VAT_Rate,Acc_Date_From = @Acc_date_From,Acc_Date_To = @Acc_date_to, StartInvoice=@StartInvoice where CompanyID=@CompanyID";
cmdInsert = new SqlCommand(strInsert, conMyData);
cmdInsert.Parameters.Add("@StartInvoice", organization.InvoiceNo);
cmdInsert.Parameters.Add("@CompanyID", organization.CompanyID);
cmdInsert.Parameters.Add("@DealerName", organization.DealerName);
cmdInsert.Parameters.Add("@DealerShip", organization.DealerShip);
cmdInsert.Parameters.Add("@Address", organization.Address);
cmdInsert.Parameters.Add("@City", organization.City);
cmdInsert.Parameters.Add("@State", organization.State);
cmdInsert.Parameters.Add("@Country", organization.Country);
cmdInsert.Parameters.Add("@PhoneNo", organization.PhoneOff);
cmdInsert.Parameters.Add("@FaxNo", organization.FaxNo);
cmdInsert.Parameters.Add("@Email", organization.EMail);
cmdInsert.Parameters.Add("@Website", organization.Website);
cmdInsert.Parameters.Add("@TinNo", organization.Tinno);
cmdInsert.Parameters.Add("@Entrytax", organization.Entrytax);
cmdInsert.Parameters.Add("@FoodLicNO", organization.FoodLicNO);
cmdInsert.Parameters.Add("@WM", organization.WMlic);
cmdInsert.Parameters.Add("@Logo", organization.Logo);
cmdInsert.Parameters.Add("@Div_Office", organization.DivOffice);
cmdInsert.Parameters.Add("@Message", organization.Message);
cmdInsert.Parameters.Add("@VAT_Rate", organization.VATRate);
cmdInsert.Parameters.Add("@Acc_date_from", organization.DateFrom);
cmdInsert.Parameters.Add("@Acc_date_to", organization.DateTo);
cmdInsert.ExecuteNonQuery();
conMyData.Close();
}
public void InsertOrganizationDetails(OrganizationModels organization)
{
SqlConnection conMyData;
string strInsert;
SqlCommand cmdInsert;
conMyData = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]);
conMyData.Open();
strInsert = "Insert Into Organisation (CompanyID,DealerName,DealerShip,Address,City,State,Country ,PhoneNo ,FaxNo ,Email,Website,TinNo,Entrytax ,FoodLicNO,WM,Logo,Div_Office,Message,VAT_Rate,Acc_Date_from,Acc_Date_to,startinvoice) " + "Values (@CompanyID,@DealerName,@DealerShip,@Address,@City,@State,@Country ,@PhoneNo,@FaxNo ,@Email,@Website,@TinNo,@Entrytax,@FoodLicNO,@WM,@Logo,@Div_Office,@Message,@VAT_Rate,@Acc_date_from,@Acc_date_To,@StartInvoice)";
cmdInsert = new SqlCommand(strInsert, conMyData);
cmdInsert.Parameters.Add("@StartInvoice", organization.InvoiceNo);
cmdInsert.Parameters.Add("@CompanyID", organization.CompanyID);
cmdInsert.Parameters.Add("@DealerName", organization.DealerName);
cmdInsert.Parameters.Add("@DealerShip", organization.DealerShip);
cmdInsert.Parameters.Add("@Address", organization.Address);
cmdInsert.Parameters.Add("@City", organization.City);
cmdInsert.Parameters.Add("@State", organization.State);
cmdInsert.Parameters.Add("@Country", organization.Country);
cmdInsert.Parameters.Add("@PhoneNo", organization.PhoneOff);
cmdInsert.Parameters.Add("@FaxNo", organization.FaxNo);
cmdInsert.Parameters.Add("@Email", organization.EMail);
cmdInsert.Parameters.Add("@Website", organization.Website);
cmdInsert.Parameters.Add("@TinNo", organization.Tinno);
cmdInsert.Parameters.Add("@Entrytax", organization.Entrytax);
cmdInsert.Parameters.Add("@FoodLicNO", organization.FoodLicNO);
cmdInsert.Parameters.Add("@WM", organization.WMlic);
cmdInsert.Parameters.Add("@Logo", organization.Logo);
cmdInsert.Parameters.Add("@Div_Office", organization.DivOffice);
cmdInsert.Parameters.Add("@Message", organization.Message);
cmdInsert.Parameters.Add("@VAT_Rate", organization.VATRate);
cmdInsert.Parameters.Add("@Acc_date_from", organization.DateFrom);
cmdInsert.Parameters.Add("@Acc_date_to", organization.DateTo);
cmdInsert.ExecuteNonQuery();
object op = null;
dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertLedger", ref op, "@Ledger_Name", "Cash", "@SubGrp_Name", "Cash in hand", "@Group_Name", "Current Assets", "@Grp_Nature", "Assets", "@Op_Bal", "0", "@Bal_Type", "Dr");
conMyData.Close();
}
public OrganizationModels GetSelectedOrganization(string OrgID)
{
InventoryClass obj = new InventoryClass();
SqlDataReader SqlDtr;
string sql;
OrganizationModels organization = new OrganizationModels();
sql = "select * from Organisation where CompanyID='" + OrgID + "'";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
organization.DealerName = SqlDtr.GetValue(1).ToString();
organization.DealerShip = SqlDtr.GetValue(2).ToString();
organization.Address = SqlDtr.GetValue(3).ToString();
organization.City = SqlDtr.GetValue(4).ToString();
organization.State = SqlDtr.GetValue(5).ToString();
organization.Country = SqlDtr.GetValue(6).ToString();
organization.PhoneOff = SqlDtr.GetValue(7).ToString();
organization.FaxNo = SqlDtr.GetValue(8).ToString();
organization.EMail = SqlDtr.GetValue(9).ToString();
organization.Website = SqlDtr.GetValue(10).ToString();
organization.Tinno = SqlDtr.GetValue(11).ToString();
organization.Entrytax = SqlDtr.GetValue(12).ToString();
organization.FoodLicNO = SqlDtr.GetValue(13).ToString();
organization.WMlic = SqlDtr.GetValue(14).ToString();
organization.StateOffice = SqlDtr.GetValue(16).ToString();
organization.Logo = SqlDtr.GetValue(15).ToString();
organization.Message = SqlDtr.GetValue(17).ToString();
organization.VATRate = SqlDtr.GetValue(18).ToString().Trim();
organization.DateFrom = SqlDtr.GetValue(19).ToString().Trim();
organization.DateTo = SqlDtr.GetValue(20).ToString().Trim();
organization.InvoiceNo = SqlDtr.GetValue(21).ToString();
}
SqlDtr.Close();
return(organization);
}