public void GetListFirmMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListFirmMaster";
FirmMaster objData = objFilter as FirmMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, objData.RecNo));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillFirmMasterDataFromReader, ref listData);
}
private void FillFirmMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
FirmMaster objData = obj as FirmMaster;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public DataBaseResultSet SaveFirmMaster <T>(T objData) where T : class, IModel, new()
{
FirmMaster obj = objData as FirmMaster;
string sQuery = "sprocFirmMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("FirmName", "FirmName", 50, GenericDataType.String, ParameterDirection.Input, obj.FirmName));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 50, GenericDataType.String, ParameterDirection.Input, obj.Add2));
list.Add(SqlConnManager.GetConnParameters("Add3", "Add3", 50, GenericDataType.String, ParameterDirection.Input, obj.Add3));
list.Add(SqlConnManager.GetConnParameters("Area", "Area", 30, GenericDataType.String, ParameterDirection.Input, obj.Area));
list.Add(SqlConnManager.GetConnParameters("City", "City", 20, GenericDataType.String, ParameterDirection.Input, obj.City));
list.Add(SqlConnManager.GetConnParameters("PinCode", "PinCode", 10, GenericDataType.String, ParameterDirection.Input, obj.PinCode));
list.Add(SqlConnManager.GetConnParameters("KeyPerson", "KeyPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.KeyPerson));
list.Add(SqlConnManager.GetConnParameters("PhoneNo", "PhoneNo", 35, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("VatNo", "VatNo", 20, GenericDataType.String, ParameterDirection.Input, obj.VatNo));
list.Add(SqlConnManager.GetConnParameters("VatDate", "VatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VatDate));
list.Add(SqlConnManager.GetConnParameters("CSTVatNo", "CSTVatNo", 20, GenericDataType.String, ParameterDirection.Input, obj.CSTVatNo));
list.Add(SqlConnManager.GetConnParameters("CSTVatDate", "CSTVatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CSTVatDate));
list.Add(SqlConnManager.GetConnParameters("DlNo1", "DlNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.DlNo1));
list.Add(SqlConnManager.GetConnParameters("DlNo2", "DlNo2", 50, GenericDataType.String, ParameterDirection.Input, obj.DlNo2));
list.Add(SqlConnManager.GetConnParameters("RegKey", "RegKey", 25, GenericDataType.String, ParameterDirection.Input, obj.RegKey));
list.Add(SqlConnManager.GetConnParameters("DataPath", "DataPath", 8, GenericDataType.String, ParameterDirection.Input, obj.DataPath));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsValid == false)
{
MessageBox.Show(AllErrors.ErrorMessageString(), Constants.ALERTMESSAGEHEADER);
return;
}
if (txtEmail.Text != String.Empty && !Regex.IsMatch(txtEmail.Text, Constants.EMAILPATTERN))
{
txtEmail.Focus();
MessageBox.Show(Resources.frmFirmMaster_btnSave_Click_Please_Enter_Valid_Email_Address_, Constants.ALERTMESSAGEHEADER);
return;
}
if (!txtTAX.Text.IsEmpty() && !txtTAX.Text.IsDecimal())
{
MessageBox.Show(Resources.frmFirmMaster_btnSave_Click_Invalid_TAX_field, Constants.ALERTMESSAGEHEADER);
return;
}
if (!txtOtherTAX.Text.IsEmpty() && !txtOtherTAX.Text.IsDecimal())
{
MessageBox.Show(Resources.frmFirmMaster_btnSave_Click_Invalid_Other_TAX_field, Constants.ALERTMESSAGEHEADER);
return;
}
if (!txtLogo.Text.IsEmpty() && !File.Exists(txtLogo.Text))
{
MessageBox.Show(Resources.frmFirmMaster_btnSave_Click_Invalid_file_Logo_path_, Constants.ALERTMESSAGEHEADER);
return;
}
var firmInfo = _firmService.GetFrimMaster();
var firmMaster = new FirmMaster
{
FirmName = txtName.Text,
FirmEmail = txtEmail.Text,
FirmHeader = txtHeaderOrSlogan.Text,
FirmWebsite = txtWebsite.Text,
FirmVATNumber = txtVATNumber.Text,
FirmTINNumber = txtTINNumber.Text,
FirmTopHeader = txtTopHeader.Text,
FirmAddress = txtAddress.Text,
FirmAdditionalInfo = txtAdditionalInformation.Text,
Tax = Convert.ToDecimal(txtTAX.Text),
OtherTax = Convert.ToDecimal(txtOtherTAX.Text),
};
if (firmInfo != null)
{
firmMaster.FirmMasterId = firmInfo.FirmMasterId;
}
if (File.Exists(txtLogo.Text))
{
var imageIn = Image.FromFile(txtLogo.Text);
File.ReadAllBytes(txtLogo.Text);
firmMaster.FirmLogo = ImageConverterHelper.ImageToByteArray(imageIn);
}
var firmRequest = new FirmMasterRequest
{
FirmMaster = firmMaster
};
_firmService.SaveFirm(firmRequest);
BindForm();
}
