public static string Insert(clsContact data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblContact oNewRow = new tblContact()
{
idContactType = data.idContactType,
idRequest = data.idRequest,
Name = data.Name,
Title = data.Title,
Phone = data.Phone,
Email = data.Email,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idContact;
data.idRequest = newID;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Update(clsContact data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
var contact = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == data.idContact).FirstOrDefault();
if (contact != null)
{
contact.Name = data.Name;
contact.Title = data.Title;
contact.Phone = data.Phone;
contact.Email = data.Email;
contact.UpdatedBy = data.UpdatedBy;
contact.UpdatedOn = data.UpdatedOn;
}
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
//update contact by contact ID, stored procedure :sp_update_contact_U
public static bool DBUpdateContact(clsContact Contact)
{
bool result = true;
SqlCommand objCommand = new SqlCommand("sp_update_contact_U");
objCommand.CommandType = CommandType.StoredProcedure;
SqlParameter prmContactID = new SqlParameter("@ContactID", SqlDbType.BigInt);
prmContactID.Value = Contact.ContactId;
objCommand.Parameters.Add(prmContactID);
SqlParameter prmFirstName = new SqlParameter("@FirstName", SqlDbType.VarChar);
prmFirstName.Value = Contact.FirstName;
objCommand.Parameters.Add(prmFirstName);
SqlParameter prmLastName = new SqlParameter("@LastName", SqlDbType.VarChar);
prmLastName.Value = Contact.LastName;
objCommand.Parameters.Add(prmLastName);
SqlParameter prmEmailID = new SqlParameter("@EmailID", SqlDbType.VarChar);
prmEmailID.Value = Contact.EmailID;
objCommand.Parameters.Add(prmEmailID);
SqlParameter prmMobileNumber = new SqlParameter("@MobileNumber", SqlDbType.VarChar);
prmMobileNumber.Value = Contact.MobileNumber;
objCommand.Parameters.Add(prmMobileNumber);
SqlParameter prmStatus = new SqlParameter("@Status", SqlDbType.Bit);
prmStatus.Value = Contact.Status;
objCommand.Parameters.Add(prmStatus);
if (DBInteraction.ExecuteSQL(ref objCommand))
{
result = true;
}
else
{
result = false;
}
if (objCommand != null)
{
objCommand.Dispose();
}
return(result);
}
public bool addContacts([FromBody] dynamic contects)
{
clsContact objContact = JsonConvert.DeserializeObject(contects, typeof(clsContact));
return(DBContact.DBAddContact(objContact));
}
public bool updateContacts([FromBody] dynamic stringContent)
{
clsContact objContact = JsonConvert.DeserializeObject(stringContent, typeof(clsContact));
return(DBContact.DBUpdateContact(objContact));
}
